Interview Questions and Answer
Options:
a. By using the Integration Services Deployment Wizard
b. By using SQL Server Management Studio
c. By using SQL Server Data Tools (Visual Studio)
d. By using the Management Object Model API
Reveal Answer
Options:
a. It allows you to deploy a SQL Server Integration Services (SSIS) project as a single unit to the SSIS Catalog
b. It allows you to deploy packages that you have updated to the SSIS Catalog without having to deploy the whole project
c. All the above
d. None of these
Reveal Answer
Options:
a. It allows you to deploy packages that you have updated to the SSIS Catalog without having to deploy the whole project
b. It allows you to deploy a SQL Server Integration Services (SSIS) project as a single unit to the SSIS Catalog
c. All the above
d. None of these
Reveal Answer
Options:
a. By using stored procedure
b. By using parameters
c. By using Configuration
d. None of these
Reveal Answer
Options:
a. list of packages
b. packages configurations
c. Any miscellaneous files in the project
d. None of these
Reveal Answer
Options:
a. SSIS Deployment Manifest
b. Deployment
c. Manifest
d. None of these
Reveal Answer
Bestdotnet google plus